SELECT * FROM Product
WHERE LatestInputPrice IS NULL
AND  EXISTS (SELECT 1 FROM InProdDetail
					WHERE ProductId = Product.Id)
					
					
SELECT BillDetail.*, Bill.SaleTime, Product.Id, Product.[Name], Product.IsDeleted
FROM BillDetail
INNER JOIN Bill
ON BillDetail.BillId = Bill.Id

INNER JOIN Product
ON BillDetail.ProductId = Product.Id
WHERE InputPrice IS NULL

SELECT * FROM Product
WHERE Id=1169

SELECT * FROM InProdDetail
WHERE ProductId = 924
ORDER BY ProductId
